package com.suyuan.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CompanyInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CompanyInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andGidIsNull() {
            addCriterion("GID is null");
            return (Criteria) this;
        }

        public Criteria andGidIsNotNull() {
            addCriterion("GID is not null");
            return (Criteria) this;
        }

        public Criteria andGidEqualTo(Integer value) {
            addCriterion("GID =", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidNotEqualTo(Integer value) {
            addCriterion("GID <>", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidGreaterThan(Integer value) {
            addCriterion("GID >", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidGreaterThanOrEqualTo(Integer value) {
            addCriterion("GID >=", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidLessThan(Integer value) {
            addCriterion("GID <", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidLessThanOrEqualTo(Integer value) {
            addCriterion("GID <=", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidIn(List<Integer> values) {
            addCriterion("GID in", values, "gid");
            return (Criteria) this;
        }

        public Criteria andGidNotIn(List<Integer> values) {
            addCriterion("GID not in", values, "gid");
            return (Criteria) this;
        }

        public Criteria andGidBetween(Integer value1, Integer value2) {
            addCriterion("GID between", value1, value2, "gid");
            return (Criteria) this;
        }

        public Criteria andGidNotBetween(Integer value1, Integer value2) {
            addCriterion("GID not between", value1, value2, "gid");
            return (Criteria) this;
        }

        public Criteria andComptypeidIsNull() {
            addCriterion("CompTypeID is null");
            return (Criteria) this;
        }

        public Criteria andComptypeidIsNotNull() {
            addCriterion("CompTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andComptypeidEqualTo(Integer value) {
            addCriterion("CompTypeID =", value, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidNotEqualTo(Integer value) {
            addCriterion("CompTypeID <>", value, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidGreaterThan(Integer value) {
            addCriterion("CompTypeID >", value, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CompTypeID >=", value, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidLessThan(Integer value) {
            addCriterion("CompTypeID <", value, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidLessThanOrEqualTo(Integer value) {
            addCriterion("CompTypeID <=", value, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidIn(List<Integer> values) {
            addCriterion("CompTypeID in", values, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidNotIn(List<Integer> values) {
            addCriterion("CompTypeID not in", values, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidBetween(Integer value1, Integer value2) {
            addCriterion("CompTypeID between", value1, value2, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andComptypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("CompTypeID not between", value1, value2, "comptypeid");
            return (Criteria) this;
        }

        public Criteria andCompnameIsNull() {
            addCriterion("CompName is null");
            return (Criteria) this;
        }

        public Criteria andCompnameIsNotNull() {
            addCriterion("CompName is not null");
            return (Criteria) this;
        }

        public Criteria andCompnameEqualTo(String value) {
            addCriterion("CompName =", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameNotEqualTo(String value) {
            addCriterion("CompName <>", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameGreaterThan(String value) {
            addCriterion("CompName >", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameGreaterThanOrEqualTo(String value) {
            addCriterion("CompName >=", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameLessThan(String value) {
            addCriterion("CompName <", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameLessThanOrEqualTo(String value) {
            addCriterion("CompName <=", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameLike(String value) {
            addCriterion("CompName like", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameNotLike(String value) {
            addCriterion("CompName not like", value, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameIn(List<String> values) {
            addCriterion("CompName in", values, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameNotIn(List<String> values) {
            addCriterion("CompName not in", values, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameBetween(String value1, String value2) {
            addCriterion("CompName between", value1, value2, "compname");
            return (Criteria) this;
        }

        public Criteria andCompnameNotBetween(String value1, String value2) {
            addCriterion("CompName not between", value1, value2, "compname");
            return (Criteria) this;
        }

        public Criteria andCompcodeIsNull() {
            addCriterion("CompCode is null");
            return (Criteria) this;
        }

        public Criteria andCompcodeIsNotNull() {
            addCriterion("CompCode is not null");
            return (Criteria) this;
        }

        public Criteria andCompcodeEqualTo(String value) {
            addCriterion("CompCode =", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeNotEqualTo(String value) {
            addCriterion("CompCode <>", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeGreaterThan(String value) {
            addCriterion("CompCode >", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeGreaterThanOrEqualTo(String value) {
            addCriterion("CompCode >=", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeLessThan(String value) {
            addCriterion("CompCode <", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeLessThanOrEqualTo(String value) {
            addCriterion("CompCode <=", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeLike(String value) {
            addCriterion("CompCode like", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeNotLike(String value) {
            addCriterion("CompCode not like", value, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeIn(List<String> values) {
            addCriterion("CompCode in", values, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeNotIn(List<String> values) {
            addCriterion("CompCode not in", values, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeBetween(String value1, String value2) {
            addCriterion("CompCode between", value1, value2, "compcode");
            return (Criteria) this;
        }

        public Criteria andCompcodeNotBetween(String value1, String value2) {
            addCriterion("CompCode not between", value1, value2, "compcode");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeIsNull() {
            addCriterion("FoundedTime is null");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeIsNotNull() {
            addCriterion("FoundedTime is not null");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeEqualTo(Date value) {
            addCriterion("FoundedTime =", value, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeNotEqualTo(Date value) {
            addCriterion("FoundedTime <>", value, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeGreaterThan(Date value) {
            addCriterion("FoundedTime >", value, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("FoundedTime >=", value, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeLessThan(Date value) {
            addCriterion("FoundedTime <", value, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeLessThanOrEqualTo(Date value) {
            addCriterion("FoundedTime <=", value, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeIn(List<Date> values) {
            addCriterion("FoundedTime in", values, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeNotIn(List<Date> values) {
            addCriterion("FoundedTime not in", values, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeBetween(Date value1, Date value2) {
            addCriterion("FoundedTime between", value1, value2, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andFoundedtimeNotBetween(Date value1, Date value2) {
            addCriterion("FoundedTime not between", value1, value2, "foundedtime");
            return (Criteria) this;
        }

        public Criteria andRegaddrIsNull() {
            addCriterion("RegAddr is null");
            return (Criteria) this;
        }

        public Criteria andRegaddrIsNotNull() {
            addCriterion("RegAddr is not null");
            return (Criteria) this;
        }

        public Criteria andRegaddrEqualTo(String value) {
            addCriterion("RegAddr =", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrNotEqualTo(String value) {
            addCriterion("RegAddr <>", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrGreaterThan(String value) {
            addCriterion("RegAddr >", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrGreaterThanOrEqualTo(String value) {
            addCriterion("RegAddr >=", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrLessThan(String value) {
            addCriterion("RegAddr <", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrLessThanOrEqualTo(String value) {
            addCriterion("RegAddr <=", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrLike(String value) {
            addCriterion("RegAddr like", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrNotLike(String value) {
            addCriterion("RegAddr not like", value, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrIn(List<String> values) {
            addCriterion("RegAddr in", values, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrNotIn(List<String> values) {
            addCriterion("RegAddr not in", values, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrBetween(String value1, String value2) {
            addCriterion("RegAddr between", value1, value2, "regaddr");
            return (Criteria) this;
        }

        public Criteria andRegaddrNotBetween(String value1, String value2) {
            addCriterion("RegAddr not between", value1, value2, "regaddr");
            return (Criteria) this;
        }

        public Criteria andCapitalIsNull() {
            addCriterion("Capital is null");
            return (Criteria) this;
        }

        public Criteria andCapitalIsNotNull() {
            addCriterion("Capital is not null");
            return (Criteria) this;
        }

        public Criteria andCapitalEqualTo(String value) {
            addCriterion("Capital =", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalNotEqualTo(String value) {
            addCriterion("Capital <>", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalGreaterThan(String value) {
            addCriterion("Capital >", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalGreaterThanOrEqualTo(String value) {
            addCriterion("Capital >=", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalLessThan(String value) {
            addCriterion("Capital <", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalLessThanOrEqualTo(String value) {
            addCriterion("Capital <=", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalLike(String value) {
            addCriterion("Capital like", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalNotLike(String value) {
            addCriterion("Capital not like", value, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalIn(List<String> values) {
            addCriterion("Capital in", values, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalNotIn(List<String> values) {
            addCriterion("Capital not in", values, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalBetween(String value1, String value2) {
            addCriterion("Capital between", value1, value2, "capital");
            return (Criteria) this;
        }

        public Criteria andCapitalNotBetween(String value1, String value2) {
            addCriterion("Capital not between", value1, value2, "capital");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNull() {
            addCriterion("Business is null");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNotNull() {
            addCriterion("Business is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessEqualTo(String value) {
            addCriterion("Business =", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotEqualTo(String value) {
            addCriterion("Business <>", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThan(String value) {
            addCriterion("Business >", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThanOrEqualTo(String value) {
            addCriterion("Business >=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThan(String value) {
            addCriterion("Business <", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThanOrEqualTo(String value) {
            addCriterion("Business <=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLike(String value) {
            addCriterion("Business like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotLike(String value) {
            addCriterion("Business not like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessIn(List<String> values) {
            addCriterion("Business in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotIn(List<String> values) {
            addCriterion("Business not in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessBetween(String value1, String value2) {
            addCriterion("Business between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotBetween(String value1, String value2) {
            addCriterion("Business not between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andLegalpnameIsNull() {
            addCriterion("LegalPName is null");
            return (Criteria) this;
        }

        public Criteria andLegalpnameIsNotNull() {
            addCriterion("LegalPName is not null");
            return (Criteria) this;
        }

        public Criteria andLegalpnameEqualTo(String value) {
            addCriterion("LegalPName =", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameNotEqualTo(String value) {
            addCriterion("LegalPName <>", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameGreaterThan(String value) {
            addCriterion("LegalPName >", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameGreaterThanOrEqualTo(String value) {
            addCriterion("LegalPName >=", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameLessThan(String value) {
            addCriterion("LegalPName <", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameLessThanOrEqualTo(String value) {
            addCriterion("LegalPName <=", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameLike(String value) {
            addCriterion("LegalPName like", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameNotLike(String value) {
            addCriterion("LegalPName not like", value, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameIn(List<String> values) {
            addCriterion("LegalPName in", values, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameNotIn(List<String> values) {
            addCriterion("LegalPName not in", values, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameBetween(String value1, String value2) {
            addCriterion("LegalPName between", value1, value2, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalpnameNotBetween(String value1, String value2) {
            addCriterion("LegalPName not between", value1, value2, "legalpname");
            return (Criteria) this;
        }

        public Criteria andLegalcodeIsNull() {
            addCriterion("LegalCode is null");
            return (Criteria) this;
        }

        public Criteria andLegalcodeIsNotNull() {
            addCriterion("LegalCode is not null");
            return (Criteria) this;
        }

        public Criteria andLegalcodeEqualTo(String value) {
            addCriterion("LegalCode =", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeNotEqualTo(String value) {
            addCriterion("LegalCode <>", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeGreaterThan(String value) {
            addCriterion("LegalCode >", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("LegalCode >=", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeLessThan(String value) {
            addCriterion("LegalCode <", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeLessThanOrEqualTo(String value) {
            addCriterion("LegalCode <=", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeLike(String value) {
            addCriterion("LegalCode like", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeNotLike(String value) {
            addCriterion("LegalCode not like", value, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeIn(List<String> values) {
            addCriterion("LegalCode in", values, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeNotIn(List<String> values) {
            addCriterion("LegalCode not in", values, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeBetween(String value1, String value2) {
            addCriterion("LegalCode between", value1, value2, "legalcode");
            return (Criteria) this;
        }

        public Criteria andLegalcodeNotBetween(String value1, String value2) {
            addCriterion("LegalCode not between", value1, value2, "legalcode");
            return (Criteria) this;
        }

        public Criteria andContactsIsNull() {
            addCriterion("Contacts is null");
            return (Criteria) this;
        }

        public Criteria andContactsIsNotNull() {
            addCriterion("Contacts is not null");
            return (Criteria) this;
        }

        public Criteria andContactsEqualTo(String value) {
            addCriterion("Contacts =", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotEqualTo(String value) {
            addCriterion("Contacts <>", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThan(String value) {
            addCriterion("Contacts >", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThanOrEqualTo(String value) {
            addCriterion("Contacts >=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThan(String value) {
            addCriterion("Contacts <", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThanOrEqualTo(String value) {
            addCriterion("Contacts <=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLike(String value) {
            addCriterion("Contacts like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotLike(String value) {
            addCriterion("Contacts not like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsIn(List<String> values) {
            addCriterion("Contacts in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotIn(List<String> values) {
            addCriterion("Contacts not in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsBetween(String value1, String value2) {
            addCriterion("Contacts between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotBetween(String value1, String value2) {
            addCriterion("Contacts not between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsphoneIsNull() {
            addCriterion("ContactsPhone is null");
            return (Criteria) this;
        }

        public Criteria andContactsphoneIsNotNull() {
            addCriterion("ContactsPhone is not null");
            return (Criteria) this;
        }

        public Criteria andContactsphoneEqualTo(String value) {
            addCriterion("ContactsPhone =", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneNotEqualTo(String value) {
            addCriterion("ContactsPhone <>", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneGreaterThan(String value) {
            addCriterion("ContactsPhone >", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneGreaterThanOrEqualTo(String value) {
            addCriterion("ContactsPhone >=", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneLessThan(String value) {
            addCriterion("ContactsPhone <", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneLessThanOrEqualTo(String value) {
            addCriterion("ContactsPhone <=", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneLike(String value) {
            addCriterion("ContactsPhone like", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneNotLike(String value) {
            addCriterion("ContactsPhone not like", value, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneIn(List<String> values) {
            addCriterion("ContactsPhone in", values, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneNotIn(List<String> values) {
            addCriterion("ContactsPhone not in", values, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneBetween(String value1, String value2) {
            addCriterion("ContactsPhone between", value1, value2, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsphoneNotBetween(String value1, String value2) {
            addCriterion("ContactsPhone not between", value1, value2, "contactsphone");
            return (Criteria) this;
        }

        public Criteria andContactsfaxIsNull() {
            addCriterion("ContactsFax is null");
            return (Criteria) this;
        }

        public Criteria andContactsfaxIsNotNull() {
            addCriterion("ContactsFax is not null");
            return (Criteria) this;
        }

        public Criteria andContactsfaxEqualTo(String value) {
            addCriterion("ContactsFax =", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxNotEqualTo(String value) {
            addCriterion("ContactsFax <>", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxGreaterThan(String value) {
            addCriterion("ContactsFax >", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxGreaterThanOrEqualTo(String value) {
            addCriterion("ContactsFax >=", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxLessThan(String value) {
            addCriterion("ContactsFax <", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxLessThanOrEqualTo(String value) {
            addCriterion("ContactsFax <=", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxLike(String value) {
            addCriterion("ContactsFax like", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxNotLike(String value) {
            addCriterion("ContactsFax not like", value, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxIn(List<String> values) {
            addCriterion("ContactsFax in", values, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxNotIn(List<String> values) {
            addCriterion("ContactsFax not in", values, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxBetween(String value1, String value2) {
            addCriterion("ContactsFax between", value1, value2, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andContactsfaxNotBetween(String value1, String value2) {
            addCriterion("ContactsFax not between", value1, value2, "contactsfax");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneIsNull() {
            addCriterion("ComplaintPhone is null");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneIsNotNull() {
            addCriterion("ComplaintPhone is not null");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneEqualTo(String value) {
            addCriterion("ComplaintPhone =", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneNotEqualTo(String value) {
            addCriterion("ComplaintPhone <>", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneGreaterThan(String value) {
            addCriterion("ComplaintPhone >", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneGreaterThanOrEqualTo(String value) {
            addCriterion("ComplaintPhone >=", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneLessThan(String value) {
            addCriterion("ComplaintPhone <", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneLessThanOrEqualTo(String value) {
            addCriterion("ComplaintPhone <=", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneLike(String value) {
            addCriterion("ComplaintPhone like", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneNotLike(String value) {
            addCriterion("ComplaintPhone not like", value, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneIn(List<String> values) {
            addCriterion("ComplaintPhone in", values, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneNotIn(List<String> values) {
            addCriterion("ComplaintPhone not in", values, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneBetween(String value1, String value2) {
            addCriterion("ComplaintPhone between", value1, value2, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andComplaintphoneNotBetween(String value1, String value2) {
            addCriterion("ComplaintPhone not between", value1, value2, "complaintphone");
            return (Criteria) this;
        }

        public Criteria andCompanylevelIsNull() {
            addCriterion("CompanyLevel is null");
            return (Criteria) this;
        }

        public Criteria andCompanylevelIsNotNull() {
            addCriterion("CompanyLevel is not null");
            return (Criteria) this;
        }

        public Criteria andCompanylevelEqualTo(Integer value) {
            addCriterion("CompanyLevel =", value, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelNotEqualTo(Integer value) {
            addCriterion("CompanyLevel <>", value, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelGreaterThan(Integer value) {
            addCriterion("CompanyLevel >", value, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("CompanyLevel >=", value, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelLessThan(Integer value) {
            addCriterion("CompanyLevel <", value, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelLessThanOrEqualTo(Integer value) {
            addCriterion("CompanyLevel <=", value, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelIn(List<Integer> values) {
            addCriterion("CompanyLevel in", values, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelNotIn(List<Integer> values) {
            addCriterion("CompanyLevel not in", values, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelBetween(Integer value1, Integer value2) {
            addCriterion("CompanyLevel between", value1, value2, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanylevelNotBetween(Integer value1, Integer value2) {
            addCriterion("CompanyLevel not between", value1, value2, "companylevel");
            return (Criteria) this;
        }

        public Criteria andCompanycertIsNull() {
            addCriterion("CompanyCert is null");
            return (Criteria) this;
        }

        public Criteria andCompanycertIsNotNull() {
            addCriterion("CompanyCert is not null");
            return (Criteria) this;
        }

        public Criteria andCompanycertEqualTo(String value) {
            addCriterion("CompanyCert =", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertNotEqualTo(String value) {
            addCriterion("CompanyCert <>", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertGreaterThan(String value) {
            addCriterion("CompanyCert >", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertGreaterThanOrEqualTo(String value) {
            addCriterion("CompanyCert >=", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertLessThan(String value) {
            addCriterion("CompanyCert <", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertLessThanOrEqualTo(String value) {
            addCriterion("CompanyCert <=", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertLike(String value) {
            addCriterion("CompanyCert like", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertNotLike(String value) {
            addCriterion("CompanyCert not like", value, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertIn(List<String> values) {
            addCriterion("CompanyCert in", values, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertNotIn(List<String> values) {
            addCriterion("CompanyCert not in", values, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertBetween(String value1, String value2) {
            addCriterion("CompanyCert between", value1, value2, "companycert");
            return (Criteria) this;
        }

        public Criteria andCompanycertNotBetween(String value1, String value2) {
            addCriterion("CompanyCert not between", value1, value2, "companycert");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}